Dataset filenames
& data path
Make a path object for the data directory and print a list of all
data files
data_path <- paste(getwd(), "Data", sep = "/")
# kable(tibble(list.files(data_path)), caption = 'List
# of Datasets (filenames)')
data_files <- list.files(path = data_path, pattern = "*.sas7bdat",
full.names = TRUE)
data_files
[1]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/allshifts_edges.sas7bdat”
[2]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/allstaff_numbyshift.sas7bdat”
[3]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/censusmax_perperson.sas7bdat”
[4]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/centrality_measures.sas7bdat”
[5]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/clusterboot_patient.sas7bdat”
[6]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/clusterboot_staff.sas7bdat”
[7]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/clusterboot.sas7bdat”
[8]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/combined35a_halfyr4.sas7bdat”
[9]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/completepat.sas7bdat”
[10]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/completepat2.sas7bdat”
[11]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/completestaff.sas7bdat”
[12]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/completestaff2.sas7bdat”
[13]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/count_rooms_used.sas7bdat”
[14]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/count_rooms_used2.sas7bdat”
[15]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/countspershift.sas7bdat”
[16]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/date_shiftnum.sas7bdat”
[17]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/degree_by_edgetype.sas7bdat”
[18]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/degree_pp_resid.sas7bdat”
[19]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/degree_ps_resid.sas7bdat”
[20]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/degree_pscat_resid.sas7bdat”
[21]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/degreepscat_resids.sas7bdat”
[22]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/edges_all_allshifts.sas7bdat”
[23]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/edges_shift19.sas7bdat”
[24]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/edges2.sas7bdat”
[25]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/eventfile_long2.sas7bdat”
[26]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/eventfile_long6944_noduploc.sas7bdat”
[27]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/events_notunique_persid.sas7bdat”
[28]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/events_uniquepersid.sas7bdat”
[29]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/events_uniquepersid2.sas7bdat”
[30]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/excessiveroomchanges.sas7bdat”
[31]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/finalsids6944.sas7bdat”
[32]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/flynn_eventfile.sas7bdat”
[33]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/id_sid_matchup.sas7bdat”
[34]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/id_sid_matchup2.sas7bdat”
[35]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/location_categories_list.sas7bdat”
[36]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/location_definitions.sas7bdat”
[37]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/locationslist.sas7bdat”
[38]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/lone_all_allshifts.sas7bdat”
[39]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/network_allshifts.sas7bdat”
[40]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/network_wts_bycombo.sas7bdat”
[41]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/network_wts_overall_nolone.sas7bdat”
[42]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/network_wts_overall.sas7bdat”
[43]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/networkall_freqbyd8.sas7bdat”
[44]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/networkall_summary.sas7bdat”
[45]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/nodelevel_all_19_halfyr_patients.sas7bdat”
[46]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/nodelevel_all_19_halfyr_staff.sas7bdat”
[47]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/nodelevel_all_19_halfyr.sas7bdat”
[48]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/nodup.sas7bdat”
[49]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/participationrates.sas7bdat”
[50]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/patients_in_completepat.sas7bdat”
[51]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/patients_notapproached.sas7bdat”
[52]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/patients_participating.sas7bdat”
[53]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/Patients_population.sas7bdat”
[54]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/patients_population2.sas7bdat”
[55]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/patients_populationwithsyndrome.sas7bdat”
[56]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/person_dataset.sas7bdat”
[57]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/popn_patients_our_shifts7.sas7bdat”
[58]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/popn_pts_our_shifts_freqbyd8.sas7bdat”
[59]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/population_35shifts.sas7bdat”
[60]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/population_first35shifts.sas7bdat”
[61]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/staff_in_edgefile2012june.sas7bdat”
[62]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/staffsids_in_eventfile.sas7bdat”
[63]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommy_edges_2009.sas7bdat”
[64]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommy_edges_shift10_19.sas7bdat”
[65]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommy_nodes_2009.sas7bdat”
[66]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommy_nodes_shift10_19.sas7bdat”
[67]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommyflynn_patient_info_2009.sas7bdat”
[68]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/tommyflynn_patient_info.sas7bdat”
[69]
“/Users/tommy-two/Documents/1_Research/2_Data_Science/0_Projects/1_NACI/Data/wdegree_bytype.sas7bdat”
# read all data files into a list of dfs
data_list <- map(data_files, read_sas)
map(data_list, glimpse)
Rows: 46,062 Columns: 15 $ i 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1,… $ any 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1,… $ staffi 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,… $ idi “7920091”, “7920091”,
“7920091”, “7920091”, “7920091”, “792… $ d8 2009-07-09,
2009-07-09, 2009-07-09, 2009-07-09, 2009-07-09… $ H1N1 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,… $ quarter 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,… $ shiftampm
2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2,… $ d9
18087, 18087, 18087, 18087, 18087, 18087, 18087, 18087, 180… $
edgeweight 0.524722222, 3.767222222, 1.111666667, 0.487222222,
0.79361… $ j 2, 3, 4, 5, 6, 7, 8, 12, 14, 15, 19, 23, 24, 25, 26,
29, 30… $ staffj 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 0, 0,… $ combo 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 1, 1,… $ idj ”7920092”, “7920093”, “7920094”, “7920095”,
“7920096”, “792… $ comboc ”2 staff-staff”, “2 staff-staff”, “2
staff-staff”, “2 staff… Rows: 359 Columns: 3 $ shift_num 1, 1, 1,
1, 8, 8, 8, 8, 10, 10, 10, 10, 17, 17, 17, 17, 19,… $ JOBTITLE
”MD”, “RN”, “RN?”, “STAFF”, “MD”, “RN”, “RN?”, “STAFF”, “MD… $
staffcount 4, 7, 5, 17, 2, 11, 4, 16, 4, 8, 3, 10, 5, 11, 5, 13,
7, 13… Rows: 4,731 Columns: 3 $ SHIFT_NUM 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1,… $ SID ”0002d045”, “0002d078”,
“0002d098”, “0002d10b”, “0… $ censusMax_perPerson 53, 41, 53, 53,
53, 46, 41, 32, 51, 52, 41, 46, 53… Rows: 81 Columns: 3 $ shift_num
1, 8, 10, 17, 19, 23, 25, 38, 43, 47, 53, 56, 63, 67, 78, 81… $
ClosCent 9.202284, 3.470755, 4.977548, 4.693836, 26.780388,
9.014041,… $ BetCent 96076.77, 91550.93, 67926.73, 159677.63,
158402.11, 83564.92… Rows: 2,374,308 Columns: 86 $ sid ”0021159c”,
“00215d4b”, “00215d82”, “00215da0… $ d8 2009-07-31, 2009-07-31,
2009-07-31, 2009-07-… $ duration_observed 252.96667, 453.00000,
96.00000, 127.90000, 77… $ censusmax_perperson 35, 38, 31, 38, 31,
38, 33, 38, 38, 38, 38, 3… $ censusmedian_perperson NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, N… $ censusmean_perperson NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ shift_num 23, 23, 23, 23,
23, 23, 23, 23, 23, 23, 23, 2… $ shiftlength 12, 12, 12, 12, 12,
12, 12, 12, 12, 12, 12, 1… $ ampm 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, … $ studyQuarter 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, … $ weekday 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
… $ staff 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
participant_type ”_PAT”, “_PAT”, “_PAT”, “_PAT”, “_PAT”, “_PAT… $
staffcount 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3… $
patcount 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 7… $
census_min 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 2… $
census_max 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3… $
patient_patient 359, 359, 359, 359, 359, 359, 359, 359, 359, … $
staff_patient 430, 430, 430, 430, 430, 430, 430, 430, 430, … $
staff_staff 400, 400, 400, 400, 400, 400, 400, 400, 400, … $
lone_patient 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
lone_staff 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ degree
15, 21, 15, 4, 26, 21, 19, 23, 19, 17, 24, 21… $ degree_pp
11, 13, 8, 2, 10, 13, 9, 13, 10, 7, 17, 12, 6… $ degree_ps 4, 8,
7, 2, 16, 8, 10, 10, 9, 10, 7, 9, 7, 5,… $ degree_ss NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, N… $ wdegree 0.96222222,
1.64722222, 0.63777778, 2.1491666… $ WDEGMIN_SS NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, N… $ wdegmin_PP 56.5000000,
47.8333333, 31.4833333, 128.30000… $ wdegmin_PS_STAFF NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, N… $ wdegmin_PS_pat 1.233333,
51.000000, 6.783333, 0.650000, 23.1… $ RELATIVE_DEGREE 0.13761468,
0.19266055, 0.13761468, 0.0366972… $ RELATIVE_DEGREE_PS_PAT
0.10526316, 0.21052632, 0.18421053, 0.0526315… $
RELATIVE_DEGREE_PS_STAFF NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, N… $ RELATIVE_DEGREE_SS NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, N… $ RELATIVE_DEGREE_PP 0.15492958, 0.18309859,
0.11267606, 0.0281690… $ LOG_WTDEGREE 0.6740776, 0.9735109,
0.4933403, 1.1471379, 0… $ Closeness_Centrality 0.5192308,
0.5373134, 0.5320197, 0.4576271, 0… $ Betweenness_Centrality
1.943202e-03, 9.593717e-03, 8.937011e-04, 1.6… $ Clustering_Coefficient
0.5047619, 0.4000000, 0.6571429, 0.8333333, 0… $
Number_of_triangles 53, 84, 69, 5, 163, 111, 86, 163, 115, 70, 13…
$ Eigenvector_Centrality 0.20128667, 0.31221947, 0.29038734,
0.0812490… $ Authority 0.006433454, 0.008845999, 0.006433454,
0.0020… $ Hub 0.006433454, 0.008845999, 0.006433454, 0.0020… $
Modularity_Class 5, 4, 4, 5, 4, 5, 5, 4, 4, 4, 5, 5, 4, 4, 5, … $
PageRank 0.007127199, 0.009297011, 0.006601165, 0.0028… $
Eccentricity 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, … $
Component_ID 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
num_shortest_paths 11772, 11772, 11772, 11772, 11772, 11772, 117…
$ weak_components 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, … $
triangle 0.5047619, 0.4000000, 0.6571429, 0.8333333, 0… $
tot_triangles 5772, 5772, 5772, 5772, 5772, 5772, 5772, 577… $
pop_high_acuity 0.2105263, 0.2105263, 0.2105263, 0.2105263, 0… $
pop_med_age 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 4… $
pop_female_freq 51.57895, 51.57895, 51.57895, 51.57895, 51.57… $
pop_black_freq 81.05263, 81.05263, 81.05263, 81.05263, 81.05… $
pop_acuity_hilo “low”, “low”, “low”, “low”, “low”, “low”, “lo… $
pop_med_age_hilo ” low”, ” low”, ” low”, ” low”, ” low”, ” low… $
pop_female_freq_hilo ” low”, ” low”, ” low”, ” low”, ” low”, ”
low… $ pop_black_freq_hilo ” low”, ” low”, ” low”, ” low”, ” low”,
” low… $ timeCoveredbyShift “stay is completely in shift”,
“startsDuring”… $ arrival_mode “Other”, “EMS”, “Other”, “EMS”,
“Other”, “Oth… $ AGE 56, 56, 40, 88, 53, 44, 42, 23, 30, 40, 34,
5… $ Sex ”Female”, “Male”, “Male”, “Male”, “Female”, “… $
ED_Disposition ”Discharge”, “Discharge”, “Discharge”, “Admit… $
admitted ”0.00%“,”100.00%“,”0.00%“,”100.00%“,”0.00… $ acuitycat
“2 Urgent”, “3 Immediate/Emergent”, “2 Urgent… $ COUNT_OF_MD
5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, … $ COUNT_OF_RN 16,
16, 16, 16, 16, 16, 16, 16, 16, 16, 16, 1… $ COUNT_OF_ST 17, 17,
17, 17, 17, 17, 17, 17, 17, 17, 17, 1… $ Syndrome ”1 Other”, “5
ChestPain”, “1 Other”, “1 Other… $ BLACKyn ”Black”, “Black”,
“Black”, “Black”, “Black”, … $ StartsDuringPct 76.38889, 76.38889,
76.38889, 76.38889, 76.38… $ musculoskel “other”, “other”,
“other”, “other”, “other”, … $ pop_respir_pct 11.6, 11.6, 11.6,
11.6, 11.6, 11.6, 11.6, 11.… $ pop_musculoskel_pct 9.5, 9.5, 9.5,
9.5, 9.5, 9.5, 9.5, 9.5, 9.5, … $ pop_chestP_pct 15.8, 15.8, 15.8,
15.8, 15.8, 15.8, 15.8, 15.… $ pop_GI_pct 11.6, 11.6, 11.6, 11.6,
11.6, 11.6, 11.6, 11.… $ pop_neuro_pct 5.3, 5.3, 5.3, 5.3, 5.3,
5.3, 5.3, 5.3, 5.3, … $ pop_othersyndrome_pct 46.3, 46.3, 46.3,
46.3, 46.3, 46.3, 46.3, 46.… $ arrive_by_EMS_pct 27.7, 27.7, 27.7,
27.7, 27.7, 27.7, 27.7, 27.… $ ParticipantCat2 “PATIENT”,
“PATIENT”, “PATIENT”, “PATIENT”, “… $ Num_uniqueRoomChanges 64,
20, 41, 6, 58, 165, 143, 171, 209, 64, 19… $ uniqueshiftnum 23,
23, 23, 23, 23, 23, 23, 23, 23, 23, 23, 2… $ Replicate 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ COUNT 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, … Rows: 1,263,609 Columns: 86 $ sid
”0002f35c”, “0002f445”, “0002f468”, “0002f469… $ d8
2009-07-31, 2009-07-31, 2009-07-31, 2009-07-… $ duration_observed
305.700000, 616.900000, 640.316667, 543.41666… $ censusmax_perperson
38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3… $
censusmedian_perperson 33.5, 32.0, 32.0, 32.5, 32.0, 32.0, 32.0,
32.… $ censusmean_perperson 33.55000, 32.63415, 32.52381,
32.97222, 32.76… $ shift_num 23, 23, 23, 23, 23, 23, 23, 23, 23,
23, 23, 2… $ shiftlength 12, 12, 12, 12, 12, 12, 12, 12, 12, 12,
12, 1… $ ampm 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $
studyQuarter 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $
weekday 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ staff
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ participant_type
”STAFF”, “STAFF”, “STAFF”, “STAFF”, “STAFF”, … $ staffcount
38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3… $ patcount 72, 72,
72, 72, 72, 72, 72, 72, 72, 72, 72, 7… $ census_min 25, 25, 25,
25, 25, 25, 25, 25, 25, 25, 25, 2… $ census_max 38, 38, 38, 38,
38, 38, 38, 38, 38, 38, 38, 3… $ patient_patient 359, 359, 359,
359, 359, 359, 359, 359, 359, … $ staff_patient 430, 430, 430,
430, 430, 430, 430, 430, 430, … $ staff_staff 400, 400, 400, 400,
400, 400, 400, 400, 400, … $ lone_patient 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, … $ lone_staff 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, … $ degree 25, 35, 31, 33, 31, 33, 30, 49, 26, 60,
26, 1… $ degree_pp NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
$ degree_ps 1, 6, 3, 4, 3, 4, 3, 23, 1, 30, 5, 4, 2, 17, … $
degree_ss 24, 29, 28, 29, 28, 29, 27, 26, 25, 30, 21, 1… $ wdegree
42.47055556, 65.79111111, 72.42444444, 71.732… $ WDEGMIN_SS
2548.083333, 3942.400000, 4329.183333, 4300.3… $ wdegmin_PP NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ wdegmin_PS_STAFF
0.1500000, 5.0666667, 16.2833333, 3.6333333, … $ wdegmin_PS_pat
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ RELATIVE_DEGREE
0.22935780, 0.32110092, 0.28440367, 0.3027522… $ RELATIVE_DEGREE_PS_PAT
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $
RELATIVE_DEGREE_PS_STAFF 0.01388889, 0.08333333, 0.04166667,
0.0555555… $ RELATIVE_DEGREE_SS 0.64864865, 0.78378378,
0.75675676, 0.7837837… $ RELATIVE_DEGREE_PP NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, N… $ LOG_WTDEGREE 3.7720838, 4.2015700,
4.2962569, 4.2867883, 4… $ Closeness_Centrality 0.5373134,
0.5869565, 0.5775401, 0.5775401, 0… $ Betweenness_Centrality
0.0003972054, 0.0043499584, 0.0017483375, 0.0… $ Clustering_Coefficient
0.9066667, 0.6840336, 0.7935484, 0.7178030, 0… $
Number_of_triangles 272, 407, 369, 379, 359, 389, 351, 511, 293, …
$ Eigenvector_Centrality 0.57107307, 0.72857176, 0.68580348,
0.6992781… $ Authority 0.010454362, 0.014475271, 0.012866908,
0.0136… $ Hub 0.010454362, 0.014475271, 0.012866908, 0.0136… $
Modularity_Class 2, 0, 2, 2, 0, 0, 2, 2, 2, 4, 1, 1, 2, 4, 0, … $
PageRank 0.009317580, 0.012781202, 0.011361925, 0.0120… $
Eccentricity 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, … $
Component_ID 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
num_shortest_paths 11772, 11772, 11772, 11772, 11772, 11772, 117…
$ weak_components 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, … $
triangle 0.9066667, 0.6840336, 0.7935484, 0.7178030, 0… $
tot_triangles 5772, 5772, 5772, 5772, 5772, 5772, 5772, 577… $
pop_high_acuity 0.2105263, 0.2105263, 0.2105263, 0.2105263, 0… $
pop_med_age 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 44, 4… $
pop_female_freq 51.57895, 51.57895, 51.57895, 51.57895, 51.57… $
pop_black_freq 81.05263, 81.05263, 81.05263, 81.05263, 81.05… $
pop_acuity_hilo “low”, “low”, “low”, “low”, “low”, “low”, “lo… $
pop_med_age_hilo ” low”, ” low”, ” low”, ” low”, ” low”, ” low… $
pop_female_freq_hilo ” low”, ” low”, ” low”, ” low”, ” low”, ”
low… $ pop_black_freq_hilo ” low”, ” low”, ” low”, ” low”, ” low”,
” low… $ timeCoveredbyShift ““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $
arrival_mode “EMS”, “Other”, ““,”“,”“,”“,”“,”“,”“,”… $ AGE
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ Sex
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ ED_Disposition
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ admitted
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ acuitycat
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ COUNT_OF_MD 5, 5, 5, 5, 5,
5, 5, 5, 5, 5, 5, 5, 5, 5, 5, … $ COUNT_OF_RN 16, 16, 16, 16, 16,
16, 16, 16, 16, 16, 16, 1… $ COUNT_OF_ST 17, 17, 17, 17, 17, 17,
17, 17, 17, 17, 17, 1… $ Syndrome
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ BLACKyn
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ StartsDuringPct 76.38889,
76.38889, 76.38889, 76.38889, 76.38… $ musculoskel
““,”“,”“,”“,”“,”“,”“,”“,”“,”“,”“,”… $ pop_respir_pct 11.6, 11.6,
11.6, 11.6, 11.6, 11.6, 11.6, 11.… $ pop_musculoskel_pct 9.5, 9.5,
9.5, 9.5, 9.5, 9.5, 9.5, 9.5, 9.5, … $ pop_chestP_pct 15.8, 15.8,
15.8, 15.8, 15.8, 15.8, 15.8, 15.… $ pop_GI_pct 11.6, 11.6, 11.6,
11.6, 11.6, 11.6, 11.6, 11.… $ pop_neuro_pct 5.3, 5.3, 5.3, 5.3,
5.3, 5.3, 5.3, 5.3, 5.3, … $ pop_othersyndrome_pct 46.3, 46.3,
46.3, 46.3, 46.3, 46.3, 46.3, 46.… $ arrive_by_EMS_pct 27.7, 27.7,
27.7, 27.7, 27.7, 27.7, 27.7, 27.… $ ParticipantCat2 “STAFF”,
“STAFF”, “STAFF”, “STAFF”, “STAFF”, … $ Num_uniqueRoomChanges 3,
43, 40, 27, 42, 22, 4, 30, 26, 310, 11, 6,… $ uniqueshiftnum 23,
23, 23, 23, 23, 23, 23, 23, 23, 23, 23, 2… $ Replicate 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ COUNT 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, … Rows: 3,637,917 Columns: 86 $ sid
“0021159c”, “00215d4b”, “00215d82”, “00215da0… $ d8 2009-07-31,
2009-07-31, 2009-07-31, 2009-07-… $ duration_observed 252.96667,
453.00000, 96.00000, 127.90000, 77… $ censusmax_perperson 35, 38,
31, 38, 31, 38, 33, 38, 38, 38, 38, 3… $ censusmedian_perperson
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ censusmean_perperson
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N… $ shift_num
23, 23, 23, 23, 23, 23, 23, 23, 23, 23, 23, 2… $ shiftlength 12,
12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 1… $ ampm 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ studyQuarter 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, … $ weekday 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, … $ staff 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, … $ participant_type ”_PAT”, “_PAT”, “_PAT”, “_PAT”, “_PAT”,
“_PAT… $ staffcount 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3…
$ patcount 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 72, 7… $
census_min 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 25, 2… $
census_max 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 38, 3… $
patient_patient 359, 359, 359, 359, 359, 359, 359, 359, 359, … $
staff_patient 430, 430, 430, 430, 430, 430, 430, 430, 430, … $
staff_staff 400, 400, 400, 400, 400, 400, 400, 400, 400, … $
lone_patient 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
lone_staff 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, … $ degree
15, 21, 15, 4, 26, 21, 19, 23, 19, 17, 24, 21… $ degree_pp
11, 13, 8, 2, 10, 13, 9, 13, 10, 7, 17, 12, 6… $ degree_ps 4, 8,
7, 2, 16, 8, 10, 10, 9, 10, 7, 9, 7, 5,… $ degree_ss NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, N… $ wdegree 0.96222222,
1.64722222, 0.63777778, 2.1491666… $ WDEGMIN_SS NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, N… $ wdegmin_PP 56.5000000,
47.8333333, 31.4833333, 128.30000… $ wdegmin_PS_STAFF NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, N… $ wdegmin_PS_pat 1.233333,
51.000000, 6.783333, 0.650000, 23.1… $ RELATIVE_DEGREE 0.13761468,
0.19266055, 0.13761468, 0.0366972… $ RELATIVE_DEGREE_PS_PAT
0.10526316, 0.21052632, 0.18421053, 0.0526315… $
RELATIVE_DEGREE_PS_STAFF NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, N… $ RELATIVE_DEGREE_SS NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, N… $ RELATIVE_DEGREE_PP 0.15492958, 0.18309859,
0.11267606, 0.0281690… $ LOG_WTDEGREE 0.6740776, 0.9735109,
0.4933403, 1.1471379, 0… $ Closeness_Centrality 0.5192308,
0.5373134, 0.5320197, 0.4576271, 0… $ Betweenness_Centrality
1.943202e-03, 9.593717e-03, 8.937011e-04, 1.6… $ Clustering_Coefficient
0.5047619, 0.4000000, 0.6571429, 0.8333333, 0… $
Number_of_triangles 53, 84, 69, 5, 163, 111, 86, 163, 115, 70, 13…
$ Eigenvector_Centrality 0.20128667, 0.31221947, 0.29038734,
0.0812490… $ Authority 0.006433454, 0.008845999, 0.006433454,
0.0020… $ Hub 0.006433454, 0.008845999, 0.006433454, 0.0020… $
Modularity_Class 5, 4, 4, 5, 4, 5, 5, 4, 4, 4, 5, 5, 4, 4, 5, … $
PageRank 0.007127199, 0.009297011, 0.006601165, 0.0028… $
Eccentricity 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, … $
Component_ID 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, … $
num_shortest_paths 11772, 11772, 11772, 11772, 11772, 11772, 117…
$ weak_components 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, … $
triangle 0.5047619, 0.4000000, 0.6571429, 0.8333333, 0… $
tot_triangles